from django.db import models


class TableShopAddress(models.Model):
    username = models.CharField(max_length=255, blank=True, null=True)
    shop_name = models.CharField(max_length=255)
    shop_phone = models.CharField(max_length=255)
    shop_address = models.CharField(max_length=255)
    shop_province = models.CharField(max_length=255)
    shop_city = models.CharField(max_length=255)
    shop_area = models.CharField(max_length=255)
    shop_class = models.CharField(max_length=255)
    shop_slogan = models.CharField(max_length=255)
    state = models.IntegerField()
    permit_url = models.CharField(max_length=255)
    electronic_contract = models.CharField(max_length=255)
    create_time = models.DateTimeField(blank=True, null=True)
    is_community = models.IntegerField(blank=True, null=True)
    contact = models.CharField(max_length=255, blank=True, null=True)
    community_name = models.CharField(max_length=255, blank=True, null=True)
    shelf_state = models.IntegerField(blank=True, null=True)
    device_no = models.CharField(max_length=255, blank=True, null=True)
    support_cate = models.CharField(max_length=255, blank=True, null=True)
    voice_state = models.IntegerField(blank=True, null=True)
    voice_url = models.CharField(max_length=255, blank=True, null=True)
    ticket_count = models.PositiveIntegerField(default=1)
    is_fastshop = models.PositiveIntegerField(default=0)
    class Meta:
        managed = False
        db_table = 'table_shop_address'
